﻿





-- 删除人员信息
create procedure [dbo].[Ryinfo_Del]
@sfzh varchar(18)
as
delete from RyCa_Info where sfzh=@sfzh -- 删除人员卡信息
delete from Bzry_Info where sfzh=@sfzh -- 删除人员班组信息
delete from Fenbry_Info where sfzh=@sfzh -- 删除人员分包信息
delete from RyPrint_Info where sfzh=@sfzh --删除人员指纹信息
delete from Ry_Info where sfzh=@sfzh